﻿----------------------------------------------------------------------Add English column-----------------------------------------------------------------
alter table system_modules add name_HK nvarchar2(50);
alter table system_modules add name_US nvarchar2(50);

alter table system_modules add descn_HK nvarchar2(255);
alter table system_modules add descn_US nvarchar2(255);

alter table system_menus add name_HK nvarchar2(50);
alter table system_menus add name_US nvarchar2(50);

alter table system_perms add operation_HK nvarchar2(100);
alter table system_perms add operation_US nvarchar2(100);

alter table portlet add name_HK nvarchar2(50);
alter table portlet add name_US nvarchar2(50);

alter table archive2_fields add name_HK nvarchar2(50);
alter table archive2_fields add name_US nvarchar2(50);

alter table supply_report add name_HK nvarchar2(50);
alter table supply_report add name_US nvarchar2(50);

-----534 样式下   首页的各种页签 表
alter table F_POR_PAGE add name_HK nvarchar2(50);
alter table F_POR_PAGE add name_US nvarchar2(50);

update portlet set name_HK = '待辦文件',name_US = 'File-to-handle' where id = 1;
update portlet set name_HK = '知識庫',name_US = 'Knowledge Center' where id = 2;
update portlet set name_HK = '通知公告',name_US = 'Bulletin' where id = 3;
update portlet set name_HK = '新聞中心',name_US = 'News' where id = 4;
update portlet set name_HK = '快捷流程',name_US = 'Fast flow' where id = 5;
update portlet set name_HK = '線上論壇',name_US = 'Forum' where id = 6;
update portlet set name_HK = '我的日程',name_US = 'My Calendar' where id = 7;
update portlet set name_HK = '我的日曆',name_US = 'My kalendar' where id = 8;
update portlet set name_HK = '檔傳遞',name_US = 'Document delivery' where id = 9;
update portlet set name_HK = '消息中心',name_US = 'Message Center' where id = 10;

--update system_dicts set name='department type',options = 'group/division/department administration/affairs department/technical department' where id = 1;
--update system_dicts set name='NOTICE Notice classification',options = 'important notice/notice of meeting/activity to convene' where id = 4;
--update system_dicts set name='session type',options = 'department meetings/high-level meeting/corporate meetings/grassroots Meeting/regular/full Assembly/salesman Meeting/middle-level cadres meeting/special meeting/Other' where id = 5;
--update system_dicts set name='file types',options = 'file types' where id = 8;
--update system_dicts set name='form classification',options = 'official category/categories of personnel/financial category/other' where id = 9;
--update system_dicts set name='job flow classification',options = 'document category/categories of personnel/financial category/Contract type/Other' where id = 10;
--update system_dicts set name='K/3',options = ' ' where id = 11;

--update system_dutys set name='default positions',descn = 'system default functions, not allowed to delete' where id = 1;

--update system_menus set name_HK = '公文交換',name_US='Document exchange'  where id =450;
--update system_menus set name_HK = '公文交換開始',name_US='The beginning of official exchange'  where id =451;
--update system_menus set name_HK = '公文交換結束',name_US='The end of document exchange'  where id =452;
--update system_menus set name_HK = '新建公文',name_US='New documents'  where id =453;
--update system_menus set name_HK = '收文箱',name_US='Received text box'  where id =454;
--update system_menus set name_HK = '發文箱',name_US='Boxes issued'  where id =455;
--update system_menus set name_HK = '交換用戶',name_US='Exchange of user'  where id =456;
--update system_menus set name_HK = '交換佇列',name_US='Exchange queue'  where id =457;
--update system_menus set name_HK = '交換歷史',name_US='Exchange history'  where id =458;

--update system_labels set name ='OA system' where id = 1;

--update system_modules set name_HK='公文交換',name_US='Document exchange' where id = 18;

--update system_roles set name='System Manager',descn = 'Have all the permissions!'  where id = 1;
--update system_roles set name='Ordinary users',descn = 'Ordinary users should have the basic competence'  where id = 3;

--update workflow_dicts set name='official language',options='documents/correspondence/letter/T' where id =1;
--update workflow_dicts set name='secret level',options='ordinary/secret/more than secret/top secret' where id =2;
--update workflow_dicts set name='submission description',options='urgent/documents/read items' where id =7;

--update workflow_shortopinion set name ='agree' where id = 1;
--update workflow_shortopinion set name ='do not agree' where id = 2;
--update workflow_shortopinion set name ='have read' where id = 3;

--update workflow_shortopinion set name ='reserved' where id = 5;
--update workflow_shortopinion set name ='reserved' where id = 6;
--update workflow_shortopinion set name ='reserved' where id = 7;
--update workflow_shortopinion set name ='reserved' where id = 8;
--update workflow_shortopinion set name ='reserved' where id = 9;
--update workflow_shortopinion set name ='reserved' where id = 10;

-- update workflow_steptype set name ='undefined',descn='undefined' where id = 0;
-- update workflow_steptype set name ='started',descn='started' where id = 1 ;
-- update workflow_steptype set name ='multi-channel',descn='multi-channel' where id = 2;
-- update workflow_steptype set name ='deal',descn='deal' where id = 3 ;
-- update workflow_steptype set name ='notice',descn='notice' where id = 4;
-- update workflow_steptype set name ='conditions',descn='conditions' where id = 5 ;
-- update workflow_steptype set name ='freedom',descn='freedom' where id = 6 ;
-- update workflow_steptype set name ='archive',descn='archive' where id = 7 ;
-- update workflow_steptype set name ='end',descn='end' where id = 8 ;
-- update workflow_steptype set name ='submanifold',descn='submanifold' where id = 9 ;
-- update workflow_steptype set name ='automatic',descn='automatic' where id = 10 ;
-- update workflow_steptype set name ='branch',descn='branch' where id = 11 ;
-- update workflow_steptype set name ='merger',descn='merger' where id = 12 ;
-- update workflow_steptype set name ='post processing',descn='post processing' where id = 103 ;
-- update workflow_steptype set name ='duties to inform',descn='duties to inform' where id = 104 ;
-- update workflow_steptype set name ='the author to deal with',descn='the author to deal with' where id = 105;
-- update workflow_steptype set name ='to inform the author',descn='to inform the author' where id = 106 ;
-- update workflow_steptype set name ='superior processing',descn='superior processing' where id = 107 ;
-- update workflow_steptype set name ='had informed his superior',descn='had informed his superior' where id = 108 ;
-- update workflow_steptype set name ='approval groups',descn='approval groups' where id = 109 ;
-- update workflow_steptype set name ='informed approval of Group',descn='informed approval of Group' where id = 110 ;

-- update cars_exes_sort set exes_name='Repair',remark='vehicle repair costs' where id = 1;
-- update cars_exes_sort set exes_name='maintenance',remark='vehicle maintenance costs' where id = 2;
-- update cars_exes_sort set exes_name='premium',remark='insurance cost categories' where id = 4;
-- update cars_exes_sort set exes_name='maintenance fee',remark='maintenance fee with categories' where id = 5;

-- update cars_fettle set fettle_name ='normal' where id = 1;
-- update cars_fettle set fettle_name ='Repair' where id = 2;
-- update cars_fettle set fettle_name ='maintenance' where id = 3;
-- update cars_fettle set fettle_name ='vehicle' where id = 4;
-- update cars_fettle set fettle_name ='end-of-life' where id = 5;

-- update archive2_fonds set fondsname='Fonds',remark='Fonds' where id =1;

-- update system_positiontype set name='default position',descn='system, the default position, please do not delete' where id =1;

-- update knowledge_catalogy_type set name='knowledge' where id=1;
-- update knowledge_catalogy_type set name='knowledge’properties' where id=2;
-- update knowledge_catalogy_type set name='readers' where id=3;

-- update workflow_reporttype set name ='specific processes' where id =1;
-- update workflow_reporttype set name ='all processes' where id =2;
-- update workflow_reporttype set name ='specific processes' where id =3;
-- update workflow_reporttype set name ='all processes' where id =4;
-- update workflow_reporttype set name ='specific processes' where id =5;
-- update workflow_reporttype set name ='all processes' where id =6;
-- update workflow_reporttype set name ='Comprehensive statistical process' where id =7;

-- update supply_report set name='staff statistical breakdown recipients' where id=1;
-- update supply_report set name='department annual cost of tables' where id=2;
-- update supply_report set name='annual cost of supplies tables' where id=3;
-- update supply_report set name='Employees to use statistical breakdown' where id=4;

update system_modules set name_HK='系統管理',descn_HK='系統管理',name_US='System Control',descn_US='System Management' where id = 1   ;
update system_modules set name_HK='協同審批',descn_HK='協同審批次處理',name_US='Workflow',descn_US='Workflow approval and deal with' where id = 2 ;
update system_modules set name_HK='知識中心',descn_HK='知識中心',name_US='Knowledge Center',descn_US='Knowledge' where id = 3   ;
update system_modules set name_HK='通知公告',descn_HK='通知公告',name_US='Bulletin',descn_US='Bulletin' where id = 5   ;
update system_modules set name_HK='日程安排',descn_HK='日程安排',name_US='Daily Schedule',descn_US='Calendar' where id = 6   ;
update system_modules set name_HK='電子郵件',descn_HK='電子郵件',name_US='Email',descn_US='Email' where id = 7   ;
update system_modules set name_HK='新聞中心',descn_HK='新聞中心',name_US='News Center',descn_US='News' where id = 8   ;
update system_modules set name_HK='會議管理',descn_HK='會議管理',name_US='Meeting Management',descn_US='Meeting' where id = 9   ;
update system_modules set name_HK='公司論壇',descn_HK='公司論壇',name_US='Business Forum',descn_US='Forum' where id = 10  ;
update system_modules set name_HK='網路硬碟',descn_HK='網路硬碟，FTP，文檔管理',name_US='File Manager',descn_US='Network hard disk, FTP, document management' where id = 11  ;
update system_modules set name_HK='設置中心',descn_HK='設置中心',name_US='Seeting',descn_US='Seeting' where id = 14  ;
update system_modules set name_HK='消息中心',descn_HK='消息中心',name_US='Message',descn_US='Message' where id = 15  ;

update system_modules set name_HK='公文交換',descn_HK='公文交換',name_US=null,descn_US=null where id = 18 ;

update system_modules set name_HK='首頁',descn_HK='系統首頁',name_US='Home',descn_US='System Home' where id = 19  ;
update system_modules set name_HK='通訊錄',descn_HK='通訊錄',name_US='Address',descn_US='Address' where id = 20  ;
update system_modules set name_HK='文件傳閱',descn_HK='文件傳閱',name_US='Document Circulation',descn_US='Docex' where id = 21  ;
update system_modules set name_HK='辦公用品',descn_HK='辦公用品',name_US='Office Supplies',descn_US='Supply' where id = 22  ;
update system_modules set name_HK='圖書管理',descn_HK='圖書管理',name_US='Books Management',descn_US='Books' where id = 23  ;
update system_modules set name_HK='車輛管理',descn_HK='車輛管理',name_US='Car-Management',descn_US='Cars' where id = 24  ;
update system_modules set name_HK='登陸日誌',descn_HK='登陸日誌管理',name_US='Login Log',descn_US='Login Log Manage' where id = 25  ;
update system_modules set name_HK='電腦報修',descn_HK='電腦報修',name_US='pc Fix',descn_US='pc Fix' where id = 26  ;
update system_modules set name_HK='檔案管理',descn_HK='檔案管理',name_US='Archive Management',descn_US='Archive' where id = 27  ;
update system_modules set name_HK='問卷調查',descn_HK='問卷調查',name_US='Voting investigation',descn_US='Ballot' where id = 28  ;
update system_modules set name_HK='人事檔案',descn_HK='人事檔案',name_US='Employee Manager',descn_US='Emp' where id = 29  ;
update system_modules set name_HK='工作任務計畫',descn_HK='工作任務計畫',name_US='WorkTask',descn_US='WorkTask' where id = 30  ;
update system_modules set name_HK='辦公用品',descn_HK='辦公用品',name_US='Office Supplies',descn_US='Supply' where id = 31  ;
update system_modules set name_HK='PL報表',descn_HK='PL報表',name_US='PL report',descn_US='PL report' where id = 32  ;
update system_modules set name_HK='我的便筏',name_US='My Notes',descn_HK='我的便筏',descn_US='Notes'  where id = 33;
update system_modules set name_HK='工作日志',name_US='Work Log',descn_HK='工作日志',descn_US='Work Log'   where id = 34;
update system_modules set name_HK='任務管理',name_US='Task Manager',descn_HK='任務管理',descn_US='Task Management'  where id = 35;
update system_modules set name_HK='計畫總結',name_US='Plan',descn_HK='計畫總結',descn_US='Plan and Summary'  where id = 36;
update system_modules set name_HK='我的日曆',name_US='Calendars',descn_HK='我的日曆',descn_US='My Calendar'   where id = 37;

update system_modules set name_HK='車輛管理',name_US='Car-Management',descn_HK='車輛管理',descn_US='Car-Management'  where id = 40;
update system_modules set name_HK='業務鏈結',name_US='Link tree',descn_HK='業務鏈結',descn_US='Link tree'  where id = 41;

update system_modules set name_HK='流程統計',name_US=null ,descn_HK='流程統計',descn_US=null   where id = 42 ;


update system_menus set name_HK = '部門管理',name_US = 'Department management' where id = 1;
update system_menus set name_HK = '用戶管理',name_US = 'User management' where id = 2;
update system_menus set name_HK = '角色管理',name_US = 'Role management' where id = 3;
update system_menus set name_HK = '系統管理',name_US = 'System Control' where id = 4;
update system_menus set name_HK = '許可權管理',name_US = 'License management' where id = 5;
update system_menus set name_HK = '資源管理',name_US = 'Resource Management' where id = 6;
update system_menus set name_HK = '協同審批',name_US = 'Document processing' where id = 9;
update system_menus set name_HK = '待辦文件',name_US = 'File-to-handle' where id = 10;
update system_menus set name_HK = '已辦文件',name_US = 'File-handled' where id = 11;
update system_menus set name_HK = '菜單開始',name_US = 'The start menu' where id = 14;
update system_menus set name_HK = '菜單結束',name_US = 'End menu' where id = 15;
update system_menus set name_HK = '模組8',name_US = 'Module 8' where id = 23;
update system_menus set name_HK = '模組9',name_US = 'Module 9' where id = 24;
update system_menus set name_HK = '模組10',name_US = 'Module 10' where id = 25;
update system_menus set name_HK = '系統字典',name_US = 'System dictionary' where id = 26;
update system_menus set name_HK = '知識中心',name_US = 'Knowledge Center' where id = 27;
update system_menus set name_HK = '基本資訊',name_US = 'Basic information' where id = 28;
update system_menus set name_HK = '基本資訊開始',name_US = 'Basic information about the beginning of' where id = 29;
update system_menus set name_HK = '個人資料',name_US = 'Individual Information' where id = 30;
update system_menus set name_HK = '修改密碼',name_US = 'Change Password' where id = 31;
update system_menus set name_HK = '基本資訊結束',name_US = 'Basic information about the end of' where id = 32;
update system_menus set name_HK = '工作流設置開始',name_US = 'Workflow set up the beginning of' where id = 33;
update system_menus set name_HK = '公文表單設置',name_US = 'document form set' where id = 34;
update system_menus set name_HK = '工作流設置',name_US = 'Workflow settings' where id = 36;
update system_menus set name_HK = '公文報表設置',name_US = 'WorkflowReport set' where id = 37;
update system_menus set name_HK = '表單樹型字典設置',name_US = 'Form-Tree-Dictionary set' where id = 38;
update system_menus set name_HK = '公文紅頭範本設置',name_US = 'Official red-headed model set' where id = 39;
update system_menus set name_HK = '工作流設置結束',name_US = 'Set the end of the workflow' where id = 40;
update system_menus set name_HK = '工作流設置',name_US = 'Workflow settings' where id = 41;
update system_menus set name_HK = '審批決策群設置',name_US = 'decision-making group set' where id = 42;
update system_menus set name_HK = '表單選擇字典設置',name_US = 'form-choose-dictionary set' where id = 43;
update system_menus set name_HK = '簽名設置',name_US = 'Signature Setup' where id = 44;
update system_menus set name_HK = '簽章設置',name_US = 'Badge Setup' where id = 45;
update system_menus set name_HK = '常用意見',name_US = 'Common opinions' where id = 46;
update system_menus set name_HK = '狀態設置',name_US = 'State set' where id = 47;
update system_menus set name_HK = '消息設置',name_US = 'Message settings' where id = 48;
update system_menus set name_HK = '部門網頁設置',name_US = 'websites Set' where id = 49;
update system_menus set name_HK = '部門網頁設置開始',name_US = 'Departments set the start page' where id = 50;
update system_menus set name_HK = '條幅設置',name_US = 'Banners set' where id = 51;
update system_menus set name_HK = '底部設置',name_US = 'Set at the bottom of' where id = 52;
update system_menus set name_HK = '部門網頁設置結束',name_US = 'Departments set up the end of the page' where id = 53;
update system_menus set name_HK = '桌面設置',name_US = 'Desktop Settings' where id = 54;
update system_menus set name_HK = '快顯功能表',name_US = 'Shortcut menu' where id = 55;
update system_menus set name_HK = '公文處理開始',name_US = 'Documents dealing with the beginning of' where id = 56;
update system_menus set name_HK = '公文處理結束',name_US = 'Documents dealing with the end of' where id = 57;
update system_menus set name_HK = '新建公文',name_US = 'New File' where id = 58;
update system_menus set name_HK = '草稿箱',name_US = 'Drafts' where id = 59;
update system_menus set name_HK = '文件監控',name_US = 'File monitoring' where id = 60;
update system_menus set name_HK = '檔觀察',name_US = 'File observed' where id = 61;
update system_menus set name_HK = '事務委託',name_US = 'affairs commissioned' where id = 62;
update system_menus set name_HK = '查詢報表',name_US = 'Query statements' where id = 63;

update system_menus set name_HK = '通訊錄',name_US = 'Contact list' where id = 68;
update system_menus set name_HK = '通訊錄開始',name_US = 'Address book began' where id = 69;
update system_menus set name_HK = '系統通訊錄',name_US = 'System Address' where id = 70;
update system_menus set name_HK = '公共通訊錄',name_US = 'Public Address' where id = 71;
update system_menus set name_HK = '個人通訊錄',name_US = 'Personal Address' where id = 72;
update system_menus set name_HK = '通訊錄結束',name_US = 'Contacts the end of' where id = 73;

update system_menus set name_HK = '職務管理',name_US = 'job management' where id = 74;
update system_menus set name_HK = '消息中心',name_US = 'Message Center' where id = 75;
update system_menus set name_HK = '消息中心開始',name_US = 'Message Center' where id = 76;
update system_menus set name_HK = '已收到消息',name_US = 'Message-in' where id = 77;
update system_menus set name_HK = '已發送消息',name_US = 'Message-out' where id = 78;
update system_menus set name_HK = '發送新消息',name_US = 'New Message' where id = 79;
update system_menus set name_HK = '消息中心結束',name_US = 'The end of Message Center' where id = 80;
update system_menus set name_HK = '用戶線上狀態',name_US = 'User online status' where id = 81;
update system_menus set name_HK = '發送手機短信',name_US = 'Send-to-Cellphone' where id = 82;
update system_menus set name_HK = '已發手機短信',name_US = 'Message-to-Cellphone' where id = 83;
update system_menus set name_HK = '發放工資條',name_US = 'Article payroll' where id = 84;

update system_menus set name_HK = '通知公告',name_US = 'Bulletin Board' where id = 104;
update system_menus set name_HK = '通知公告開始',name_US = 'Notice the beginning of' where id = 105;
update system_menus set name_HK = '通知公告結束',name_US = 'Notice the end of notice' where id = 107;
update system_menus set name_HK = '最新公告',name_US = 'Lastest bulletin' where id = 108;
update system_menus set name_HK = '新建公告',name_US = 'New bulletin Setup' where id = 109;
update system_menus set name_HK = '歷史公告',name_US = 'History bulletin' where id = 110;

update system_menus set name_HK = '新聞中心',name_US = 'News Center' where id = 111;
update system_menus set name_HK = '新聞中心開始',name_US = 'News Center' where id = 112;
update system_menus set name_HK = '最新的新聞',name_US = 'Latest news' where id = 113;
update system_menus set name_HK = '新聞中心結束',name_US = 'Press the end of' where id = 114;
update system_menus set name_HK = '待審核的新聞',name_US = 'News pending' where id = 115;
update system_menus set name_HK = '我發表的新聞',name_US = 'My News' where id = 116;
update system_menus set name_HK = '新聞欄目管理',name_US = 'News column Management' where id = 117;
update system_menus set name_HK = '電子郵件',name_US = 'E-mail' where id = 118;
update system_menus set name_HK = '電子郵件開始',name_US = 'E-mail to start' where id = 119;
update system_menus set name_HK = '收郵件',name_US = 'Mail-in' where id = 120;
update system_menus set name_HK = '寫郵件',name_US = 'Mail-out' where id = 121;
update system_menus set name_HK = '外部郵箱設置',name_US = 'Account No. Setup' where id = 122;
update system_menus set name_HK = '電子郵件結束',name_US = 'E-mail the end of' where id = 123;

update system_menus set name_HK = '知識中心開始',name_US = 'Knowledge Center' where id = 125;
update system_menus set name_HK = '知識中心首頁',name_US = 'Knowledge Centre Home Page' where id = 126;
update system_menus set name_HK = '我收藏的文章',name_US = 'Collection of articles I' where id = 127;
update system_menus set name_HK = '我借閱的文章',name_US = 'I borrow the article' where id = 128;
update system_menus set name_HK = '待審核的文章',name_US = 'Wait audit article' where id = 129;
update system_menus set name_HK = '處理借閱申請',name_US = 'Application Handling' where id = 130;
update system_menus set name_HK = '知識分類管理',name_US = 'knowledge Categories' where id = 131;
update system_menus set name_HK = '新聞中心結束',name_US = 'Press the end of' where id = 133;
update system_menus set name_HK = '我的首頁',name_US = 'Home Page' where id = 134;
update system_menus set name_HK = '知識欄目導航',name_US = 'Knowledge navigation' where id = 135;
update system_menus set name_HK = '我發表的文章',name_US = 'I published an article' where id = 136;

update system_menus set name_HK = '日程安排',name_US = 'Daily Schedule' where id = 137;
update system_menus set name_HK = '日程安排開始',name_US = 'Schedule to start' where id = 138;
update system_menus set name_HK = '我安排的日程',name_US = 'My Schedule' where id = 139;
update system_menus set name_HK = '按年查看日程',name_US = 'View-By-Year' where id = 140;
update system_menus set name_HK = '按月查看日程',name_US = 'View-By-Month' where id = 141;
update system_menus set name_HK = '日程安排結束',name_US = 'Scheduling the end of' where id = 142;

update system_menus set name_HK = '會議管理',name_US = 'Meeting Management' where id = 143;
update system_menus set name_HK = '會議管理開始',name_US = 'The beginning of Conference Management' where id = 144;
update system_menus set name_HK = '我召集的會議',name_US = 'My created meetings' where id = 145;
update system_menus set name_HK = '會議室管理',name_US = 'Meeting-room Management' where id = 146;
update system_menus set name_HK = '會議室預約',name_US = 'Meeting-room Booking' where id = 147;
update system_menus set name_HK = '會議管理結束',name_US = 'The end of Conference Management' where id = 148;
update system_menus set name_HK = '企業論壇',name_US = 'Business Forum' where id = 149;
update system_menus set name_HK = '論壇開始',name_US = 'Forum' where id = 150;
update system_menus set name_HK = '分類導航',name_US = 'Category navigation' where id = 151;
update system_menus set name_HK = '分類管理',name_US = 'Category Management' where id = 152;
update system_menus set name_HK = '許可權管理',name_US = 'Rights management' where id = 153;
update system_menus set name_HK = '論壇結束',name_US = 'Forum' where id = 154;

update system_menus set name_HK = '按周查看日程',name_US = 'View-By-Week' where id = 155;
update system_menus set name_HK = '歷史會議',name_US = 'History Meetings' where id = 156;

update system_menus set name_HK = '待參加日程',name_US = 'Pending Schedule' where id = 157;

update system_menus set name_HK = '註冊資訊',name_US = 'Registration Information' where id = 158;
update system_menus set name_HK = '文件傳閱',name_US = 'Document Circulation' where id = 159;
update system_menus set name_HK = '檔傳閱開始',name_US = 'Circulated to the beginning of file' where id = 160;
update system_menus set name_HK = '傳閱一覽',name_US = 'Circulation Details' where id = 161;
update system_menus set name_HK = '新建傳閱',name_US = 'New circulation' where id = 162;
update system_menus set name_HK = '收件箱',name_US = 'Inbox' where id = 163;
update system_menus set name_HK = '發件箱',name_US = 'Outbox' where id = 164;
update system_menus set name_HK = '收藏箱',name_US = 'Favorite' where id = 165;
update system_menus set name_HK = '回收箱',name_US = 'Recycle Bin' where id = 166;
update system_menus set name_HK = '文件傳閱結束',name_US = 'Circulation of papers end' where id = 167;
update system_menus set name_HK = '待參加會議',name_US = 'Meeting-to-attend' where id = 168;

update system_menus set name_HK = '歷史日程',name_US = 'History schedule' where id = 169;

update system_menus set name_HK = '已刪文件',name_US = 'Deleted files' where id = 170;
update system_menus set name_HK = '查詢文件',name_US = 'Query File' where id = 171;
update system_menus set name_HK = '草稿箱',name_US = 'Draft' where id = 172;

update system_menus set name_HK = '圖書管理',name_US = 'Books Management' where id = 175;
update system_menus set name_HK = '圖書管理開始',name_US = 'The beginning of library management' where id = 176;
update system_menus set name_HK = '圖書室管理',name_US = 'Library management' where id = 177;
update system_menus set name_HK = '圖書分類管理',name_US = 'Books Category' where id = 178;
update system_menus set name_HK = '圖書入庫',name_US = 'Books storage' where id = 179;
update system_menus set name_HK = '新書推薦',name_US = 'New Books Recommendation' where id = 180;
update system_menus set name_HK = '借閱管理',name_US = 'Books borrow' where id = 181;
update system_menus set name_HK = '歸還管理',name_US = 'Books Return' where id = 182;
update system_menus set name_HK = '我的借閱',name_US = 'My borrow' where id = 183;
update system_menus set name_HK = '圖書催還',name_US = 'Book return' where id = 184;
update system_menus set name_HK = '圖書管理結束',name_US = 'The end of library management' where id = 185;

update system_menus set name_HK = '辦公用品',name_US = 'Office Supplies' where id = 200;
update system_menus set name_HK = '辦公用品開始',name_US = 'The beginning of office supplies' where id = 201;
update system_menus set name_HK = '庫房管理',name_US = 'Treasury Management' where id = 202;
update system_menus set name_HK = '分類管理',name_US = 'Category Management' where id = 203;
update system_menus set name_HK = '物品管理',name_US = 'Articles management' where id = 204;
update system_menus set name_HK = '入庫登記',name_US = 'Storage register' where id = 205;
update system_menus set name_HK = '領用管理',name_US = 'Recipients management' where id = 206;
update system_menus set name_HK = '借出歸還',name_US = 'Made the return of' where id = 207;
update system_menus set name_HK = '物品盤點',name_US = 'Inventory items' where id = 208;
update system_menus set name_HK = '統計報表',name_US = 'Statistics' where id = 209;
update system_menus set name_HK = '辦公用品結束',name_US = 'The end of office supplies' where id = 210;
update system_menus set name_HK = '其他設置',name_US = 'Other settings' where id = 211;
update system_menus set name_HK = '友情連接開始',name_US = 'Link to start' where id = 212;
update system_menus set name_HK = '友情連接設置',name_US = 'Friendship Connection' where id = 213;
update system_menus set name_HK = '友情連接結束',name_US = 'Link the end of' where id = 214;
update system_menus set name_HK = '自定義檔夾',name_US = 'Custom Folder' where id = 234;
update system_menus set name_HK = '高級搜索',name_US = 'Advanced Search' where id = 235;
update system_menus set name_HK = '我發起的帖子',name_US = 'I launched posts' where id = 236;
update system_menus set name_HK = '我回復的帖子',name_US = 'I replied to the post' where id = 237;
update system_menus set name_HK = '報修申請單',name_US = 'Apply for a single repair' where id = 238;
update system_menus set name_HK = '報修處理分配',name_US = 'To deal with the distribution of repair' where id = 239;
update system_menus set name_HK = '故障類型',name_US = 'Fault type' where id = 240;
update system_menus set name_HK = '報修處理委託',name_US = 'Commissioned to deal with repair' where id = 241;
update system_menus set name_HK = '報修處理',name_US = 'Repair to deal with' where id = 242;
update system_menus set name_HK = '電腦報修結束',name_US = 'The end of the computer repair' where id = 243;
update system_menus set name_HK = '電腦報修管理',name_US = 'Computer repair management' where id = 244;
update system_menus set name_HK = '電腦報修開始',name_US = 'The beginning of computer repair' where id = 245;
update system_menus set name_HK = '我收藏的帖子',name_US = 'My collection of posts' where id = 260;
update system_menus set name_HK = '年假維護管理',name_US = 'Annual maintenance and management' where id = 280;
update system_menus set name_HK = '網路硬碟',name_US = 'Document Management' where id = 290;
update system_menus set name_HK = '文檔管理開始',name_US = 'The beginning of document management' where id = 291;
update system_menus set name_HK = '文檔管理結束',name_US = 'The end of document management' where id = 292;
update system_menus set name_HK = '文檔流覽',name_US = 'Document browsing' where id = 293;
update system_menus set name_HK = '授權管理',name_US = 'Authorized management' where id = 294;
update system_menus set name_HK = '空間管理',name_US = 'Space Management' where id = 295;
update system_menus set name_HK = '登陸日誌',name_US = 'Log landing' where id = 299;
update system_menus set name_HK = '登陸日誌管理',name_US = 'Log Management landing' where id = 300;
update system_menus set name_HK = '登陸日誌管理開始',name_US = 'Log Management began landing' where id = 301;
update system_menus set name_HK = '線上用戶查詢',name_US = 'On-line user query' where id = 302;
update system_menus set name_HK = '我的日誌',name_US = 'My log' where id = 303;
update system_menus set name_HK = '上下班時間設置',name_US = 'working time management' where id = 304;
update system_menus set name_HK = '登陸日誌管理結束',name_US = 'Management of the end of the log landing' where id = 305;
update system_menus set name_HK = '調查投票',name_US = 'Voting investigation' where id = 306;
update system_menus set name_HK = '調查投票開始',name_US = 'Voting investigation' where id = 307;
update system_menus set name_HK = '問卷分類管理',name_US = 'ballot Category management' where id = 308;
update system_menus set name_HK = '參與問卷調查',name_US = 'vote' where id = 309;
update system_menus set name_HK = '發佈問卷調查',name_US = 'setting questionnaire' where id = 310;
update system_menus set name_HK = '調查投票結束',name_US = 'The end of the survey to vote' where id = 311;

update system_menus set name_HK = '車輛使用管理',name_US = 'Car-Management' where id = 312;
update system_menus set name_HK = '車輛使用開始',name_US = 'Vehicles began to' where id = 313;
update system_menus set name_HK = '車輛預約',name_US = 'Car-booking' where id = 314;
update system_menus set name_HK = '部門審批',name_US = 'Dept approval' where id = 315;
update system_menus set name_HK = '車管處理',name_US = 'Car-Manager approval' where id = 316;
update system_menus set name_HK = '歸車登記',name_US = 'Car-returning' where id = 317;
update system_menus set name_HK = '車輛使用結束',name_US = 'The end of vehicles' where id = 318;
update system_menus set name_HK = '車輛資訊管理',name_US = 'Car Information' where id = 319;
update system_menus set name_HK = '車輛資訊開始',name_US = 'Vehicle information to start' where id = 320;
update system_menus set name_HK = '車隊信息',name_US = 'Team Information' where id = 321;
update system_menus set name_HK = '車輛分類',name_US = 'vehicle category' where id = 322;
update system_menus set name_HK = '車輛檔案',name_US = 'vehicle records' where id = 323;

update system_menus set name_HK = '司機管理',name_US = 'Driver Management' where id = 324;
update system_menus set name_HK = '維修保養',name_US = 'vehicle maintenance' where id = 325;
update system_menus set name_HK = '日常檢查',name_US = 'Routine inspections' where id = 326;
update system_menus set name_HK = '事故登記',name_US = 'Accident Record' where id = 327;
update system_menus set name_HK = '違章處理',name_US = 'Peccancy Handling' where id = 328;
update system_menus set name_HK = '車輛報廢',name_US = 'vehicles scrapped' where id = 329;
update system_menus set name_HK = '車輛調撥',name_US = 'vehicle allocation' where id = 330;
update system_menus set name_HK = '車輛資訊結束',name_US = 'The end of the vehicle information' where id = 331;
update system_menus set name_HK = '車輛費用管理',name_US = 'Car-fees' where id = 332;
update system_menus set name_HK = '車輛費用開始',name_US = 'Vehicles started' where id = 333;
update system_menus set name_HK = '費用登記',name_US = 'cost registration' where id = 334;
update system_menus set name_HK = '費用類別',name_US = 'cost categories' where id = 335;
update system_menus set name_HK = '車輛費用結束',name_US = 'The cost of the end of the vehicle' where id = 336;
update system_menus set name_HK = '統計查詢管理',name_US = 'Car Enquiry' where id = 337;
update system_menus set name_HK = '統計查詢開始',name_US = 'Statistical inquiry began' where id = 338;
update system_menus set name_HK = '使用情況統計',name_US = 'Usage statistics' where id = 339;
update system_menus set name_HK = '油耗表',name_US = 'Fuel consumption table' where id = 340;
update system_menus set name_HK = '費用報表',name_US = 'cost of statements' where id = 341;
update system_menus set name_HK = '統計查詢結束',name_US = 'The end of Statistics Query' where id = 342;

update system_menus set name_HK = '檔案管理',name_US = 'Archive Management' where id = 400;
update system_menus set name_HK = '檔案管理開始',name_US = 'The beginning of the file management' where id = 401;
update system_menus set name_HK = '文件管理',name_US = 'Document Management' where id = 402;
update system_menus set name_HK = '檔案管理',name_US = 'Archive Management' where id = 403;
update system_menus set name_HK = '借閱管理',name_US = 'Borrow Management' where id = 404;
update system_menus set name_HK = '我的收藏',name_US = 'My Favorites' where id = 405;
update system_menus set name_HK = '全宗設置',name_US = 'Fond settings' where id = 406;
update system_menus set name_HK = '門類設置',name_US = 'Category set' where id = 407;
update system_menus set name_HK = '檔案管理結束',name_US = 'End of file management' where id = 408;
update system_menus set name_HK = '高級查詢',name_US = 'Advanced Search' where id = 409;
update system_menus set name_HK = 'PL報表',name_US = 'Principal statements' where id = 420;
update system_menus set name_HK = 'PL報表開始',name_US = 'Principal statements began' where id = 421;
update system_menus set name_HK = 'PL報表結束',name_US = 'Statements for the end of the Principal' where id = 422;
update system_menus set name_HK = '自由分攤',name_US = 'Free sharing' where id = 423;
update system_menus set name_HK = '商場費用',name_US = 'Costs of shopping malls' where id = 424;
update system_menus set name_HK = '報銷分攤',name_US = 'Reimbursement of assessments' where id = 425;
update system_menus set name_HK = '統計報表',name_US = 'Statistics' where id = 426;
update system_menus set name_HK = '科目設置',name_US = 'Subjects set' where id = 427;
update system_menus set name_HK = '資料字典',name_US = 'Data Dictionary' where id = 428;
update system_menus set name_HK = '許可權設置',name_US = 'Permission settings' where id = 429;


-----此处菜单英文保留
update system_menus set name_HK = '業務鏈結',name_US = null where id = 430;
update system_menus set name_HK = '業務鏈結開始',name_US = null  where id = 431;
update system_menus set name_HK = '業務鏈結查看',name_US = null  where id = 432;
update system_menus set name_HK = '分類設置',name_US = null  where id = 433;
update system_menus set name_HK = '鏈結設置',name_US = null  where id = 434;
update system_menus set name_HK = '業務鏈結結束',name_US = null  where id = 435;
update system_menus set name_HK = '我的便簽',name_US = null  where id = 440;
update system_menus set name_HK = '我的便簽開始',name_US = null  where id = 441;
update system_menus set name_HK = '我的便簽',name_US = null  where id = 442;
update system_menus set name_HK = '我的便簽結束',name_US = null  where id = 443;
update system_menus set name_HK = '日誌管理',name_US = null  where id = 444;
update system_menus set name_HK = '日誌管理開始',name_US = null  where id = 445;
update system_menus set name_HK = '日誌錄入',name_US = null  where id = 446;
update system_menus set name_HK = '日誌查詢',name_US = null  where id = 447;
update system_menus set name_HK = '報表匯總',name_US = null  where id = 448;
update system_menus set name_HK = '日誌管理結束',name_US = null  where id = 449;
update system_menus set name_HK = '公文交換',name_US = null  where id = 450;
update system_menus set name_HK = '公文交換開始',name_US = null  where id = 451;
update system_menus set name_HK = '公文交換結束',name_US = null  where id = 452;
update system_menus set name_HK = '新建公文',name_US = null  where id = 453;
update system_menus set name_HK = '收文箱',name_US = null  where id = 454;
update system_menus set name_HK = '發文箱',name_US = null  where id = 455;
update system_menus set name_HK = '交換用戶',name_US = null  where id = 456;
update system_menus set name_HK = '交換佇列',name_US = null  where id = 457;
update system_menus set name_HK = '交換歷史',name_US = null  where id = 458;
update system_menus set name_HK = '便簽設置',name_US = null  where id = 459;
update system_menus set name_HK = '任務管理',name_US = null  where id = 460;
update system_menus set name_HK = '任務管理開始',name_US = null  where id = 461;
update system_menus set name_HK = '創建任務',name_US = null  where id = 462;
update system_menus set name_HK = '待辦任務',name_US = null  where id = 463;
update system_menus set name_HK = '我佈置的任務',name_US = null where id = 464;
update system_menus set name_HK = '已完成的任務',name_US = null  where id = 465;
update system_menus set name_HK = '異常的任務',name_US = null  where id = 466;
update system_menus set name_HK = '所有任務',name_US = null where id = 467;
update system_menus set name_HK = '任務管理結束',name_US = null  where id = 468;
update system_menus set name_HK = '計畫總結',name_US = null  where id = 470;
update system_menus set name_HK = '計畫總結開始',name_US = null where id = 471;
update system_menus set name_HK = '計畫錄入',name_US = null  where id = 472;
update system_menus set name_HK = '計畫查詢',name_US = null  where id = 473;
update system_menus set name_HK = '計畫設置',name_US = null  where id = 474;
update system_menus set name_HK = '計畫總結結束',name_US = null  where id = 475;
update system_menus set name_HK = '我的日曆',name_US = null  where id = 480;
update system_menus set name_HK = '我的日曆開始',name_US = null  where id = 481;
update system_menus set name_HK = '按天查看',name_US = null  where id = 482;
update system_menus set name_HK = '按周查看',name_US = null  where id = 483;
update system_menus set name_HK = '按月查看',name_US = null  where id = 484;
update system_menus set name_HK = '按年查看',name_US = null  where id = 485;
update system_menus set name_HK = '我的日曆結束',name_US = null  where id = 486;
update system_menus set name_HK = '管理設置',name_US = null  where id = 494;
update system_menus set name_HK = '收件箱',name_US = null  where id = 495;
update system_menus set name_HK = '發件箱',name_US = null  where id = 496;
update system_menus set name_HK = '草稿箱',name_US = null  where id = 497;
update system_menus set name_HK = '垃圾箱',name_US = null  where id = 498;


update system_menus set name_HK = '流程歸檔',name_US = 'document archiving' where id = 499;
update system_menus set name_HK = '人事檔案',name_US = 'Personnel files' where id = 539;
update system_menus set name_HK = '人事檔案開始',name_US = 'Personnel files to start' where id = 540;
update system_menus set name_HK = '基本資料設置',name_US = 'basic information Set' where id = 541;
update system_menus set name_HK = '人事資料管理',name_US = 'Personnel data management' where id = 542;
update system_menus set name_HK = '人事檔案結束',name_US = 'The end of the personnel files' where id = 545;
update system_menus set name_HK = '報表統計',name_US = 'Report Statistics' where id = 546;
update system_menus set name_HK = '公文統計',name_US = 'Official statistics' where id = 547;
update system_menus set name_HK = '基本資料管理',name_US = 'Basic data management' where id = 549;
update system_menus set name_HK = '基本資料管理開始',name_US = 'The beginning of the basic data management' where id = 550;
update system_menus set name_HK = '基本資料設置',name_US = 'Set up the basic information' where id = 551;
update system_menus set name_HK = '專案工程管理',name_US = 'Ad hoc project management' where id = 552;
update system_menus set name_HK = '基本資料管理結束',name_US = 'The end of the basic data management' where id = 553;
update system_menus set name_HK = '個人工作任務管理',name_US = 'Management of individual tasks' where id = 554;
update system_menus set name_HK = '個人任務管理開始',name_US = 'Individuals to start Task Manager' where id = 555;
update system_menus set name_HK = '任務日曆顯示',name_US = 'Calendar display task' where id = 556;
update system_menus set name_HK = '個人工作任務管理',name_US = 'Management of individual tasks' where id = 557;
update system_menus set name_HK = '個人任務管理結束',name_US = 'The end of the personal task management' where id = 558;
update system_menus set name_HK = '任務管理',name_US = 'Task Manager' where id = 559;
update system_menus set name_HK = '任務管理開始',name_US = 'Task Manager to start' where id = 560;
update system_menus set name_HK = '新建任務',name_US = 'New Task' where id = 561;
update system_menus set name_HK = '任務分配管理',name_US = 'The distribution of management tasks' where id = 562;
update system_menus set name_HK = '任務驗收管理',name_US = 'Acceptance of management tasks' where id = 563;
update system_menus set name_HK = '任務進度管理',name_US = 'The progress of management tasks' where id = 564;
update system_menus set name_HK = '任務管理結束',name_US = 'The end of Task Manager' where id = 568;
update system_menus set name_HK = '任務統計&查詢',name_US = 'Statistics and query tasks' where id = 569;
update system_menus set name_HK = '任務統計&查詢開始',name_US = 'Statistics and inquiry to start the task' where id = 570;
update system_menus set name_HK = '任務總工時統計',name_US = 'Task of the total working hours and Statistics' where id = 571;
update system_menus set name_HK = '任務完成率統計',name_US = 'Task completion rate statistics' where id = 572;
update system_menus set name_HK = '任務查詢',name_US = 'Task query' where id = 573;
update system_menus set name_HK = '末能完成任務查詢',name_US = 'unfinish task query' where id = 574;
update system_menus set name_HK = '任務統計&查詢結束',name_US = 'The end of mission statistics and inquiry' where id = 579;

update system_menus set name_HK = '我的公告',name_US = 'My bulletin' where id = 580;
update system_menus set name_HK = '公告審核',name_US = 'Bulletin Audit' where id = 581;

update system_menus set name_HK = '公告板',name_US = null  where id = 582;

update system_menus set name_HK = '知識地圖導航',name_US = 'Knowledge Map' where id = 600;
update system_menus set name_HK = '分類管理',name_US = 'Categories' where id = 601;

update system_menus set name_HK = '辦公用品',name_US = 'Office Supplies' where id = 610;
update system_menus set name_HK = '辦公用品開始',name_US = 'The beginning of office supplies' where id = 611;
update system_menus set name_HK = '個人申請',name_US = 'Personal application' where id = 612;
update system_menus set name_HK = '入庫管理 ',name_US = 'Storage management' where id = 613;
update system_menus set name_HK = '出庫管理 ',name_US = 'out of warehouse ' where id = 614;
update system_menus set name_HK = '審核管理 ',name_US = 'Audit Management' where id = 615;
update system_menus set name_HK = '盤點管理 ',name_US = 'Inventory management' where id = 616;
update system_menus set name_HK = '採購計畫 ',name_US = 'Purchasing Plan' where id = 617;
update system_menus set name_HK = '報表管理 ',name_US = 'Report Management' where id = 618;
update system_menus set name_HK = '分類管理 ',name_US = 'Classification management' where id = 619;
update system_menus set name_HK = '庫房管理 ',name_US = 'warehouse management' where id = 620;

update system_menus set name_HK = '盤點管理 ',name_US = 'Inventory management' where id = 621;

update system_menus set name_HK = '辦公用品結束',name_US = 'The end of office supplies' where id = 625;
update system_menus set name_HK = '職位級別',name_US = 'positions level' where id = 800;
update system_menus set name_HK = '職位管理',name_US = 'Post Management' where id = 801;
update system_menus set name_HK = '採購計畫',name_US = 'Procurement plan' where id = 888;
update system_menus set name_HK = '操作日誌',name_US = 'Log Handling' where id = 889;
update system_menus set name_HK = '同步管理',name_US = 'Synchronization Manager' where id = 890;
update system_menus set name_HK = '待審核的會議',name_US = 'Wait Audit Meeting' where id = 891;
update system_menus set name_HK = '日誌報表',name_US = 'Log statements' where id = 894;
update system_menus set name_HK = '表單樹形字典設置',name_US = 'Dictionary tree form set' where id = 901;
update system_menus set name_HK = '標籤管理',name_US = 'Label Management' where id = 902;
update system_menus set name_HK = '首頁管理',name_US = 'Home Management' where id = 903;
update system_menus set name_HK = '流程轉換設置',name_US = 'Flow Conversion set' where id = 904;


update system_menus set name_HK = '頁簽管理',name_US = null where id = 905;
update system_menus set name_HK = '會議服務管理',name_US = null where id = 908;
update system_menus set name_HK = '車輛使用管理',name_US = null where id = 910;
update system_menus set name_HK = '車輛使用開始',name_US = null where id = 911;
update system_menus set name_HK = '車輛申請',name_US = null where id = 912;
update system_menus set name_HK = '部門審批',name_US = null where id = 913;
update system_menus set name_HK = '車管處理',name_US = null where id = 914;
update system_menus set name_HK = '回車登記',name_US = null where id = 915;
update system_menus set name_HK = '車輛使用結束',name_US = null where id = 916;
update system_menus set name_HK = '車輛資訊管理',name_US = null where id = 917;
update system_menus set name_HK = '車輛資訊開始',name_US = null where id = 918;
update system_menus set name_HK = '車隊信息',name_US = null where id = 919;
update system_menus set name_HK = '車輛分類',name_US = null where id = 920;
update system_menus set name_HK = '車輛檔案',name_US = null where id = 921;
update system_menus set name_HK = '司機管理',name_US = null where id = 922;
update system_menus set name_HK = '維修保養單位',name_US = null where id = 923;
update system_menus set name_HK = '日常檢查',name_US = null where id = 924;
update system_menus set name_HK = '事故登記',name_US = null where id = 925;
update system_menus set name_HK = '違章處理',name_US = null where id = 926;
update system_menus set name_HK = '車輛報廢',name_US = null where id = 927;
update system_menus set name_HK = '車輛調撥',name_US = null where id = 928;
update system_menus set name_HK = '車輛資訊結束',name_US = null where id = 929;
update system_menus set name_HK = '車輛費用管理',name_US = null where id = 930;
update system_menus set name_HK = '車輛費用開始',name_US = null where id = 931;
update system_menus set name_HK = '費用登記',name_US = null where id = 932;
update system_menus set name_HK = '費用類別',name_US = null where id = 933;
update system_menus set name_HK = '車輛費用結束',name_US = null where id = 934;
update system_menus set name_HK = '統計查詢管理',name_US = null where id = 935;
update system_menus set name_HK = '統計查詢開始',name_US = null where id = 936;
update system_menus set name_HK = '車輛資訊查詢',name_US = null where id = 937;
update system_menus set name_HK = '費用報表',name_US = null where id = 939;
update system_menus set name_HK = '統計查詢結束',name_US = null where id = 940;
update system_menus set name_HK = '車輛年審',name_US = null where id = 941;
update system_menus set name_HK = '維修保養',name_US = null where id = 942;
update system_menus set name_HK = '範本管理',name_US = null where id = 945;
update system_menus set name_HK = '工作時間管理',name_US = null  where id = 955;
update system_menus set name_HK = '報表統計',name_US = null  where id = 960;
update system_menus set name_HK = '報表統計設置開始',name_US = null  where id = 961;
update system_menus set name_HK = '流程檔統計',name_US = null  where id = 962;
update system_menus set name_HK = '流程步驟時效統計',name_US = null  where id = 963;
update system_menus set name_HK = '流程分類用時統計',name_US = null  where id = 964;
update system_menus set name_HK = '流程綜合統計',name_US = null  where id = 964;
update system_menus set name_HK = '辦文數量統計',name_US = null  where id = 966;
update system_menus set name_HK = '報表統計設置結束',name_US = null  where id = 967;
update system_menus set name_HK = '安全設置',name_US = null  where id = 970;
update system_menus set name_HK = '基礎資料導入',name_US = null  where id = 971;
update system_menus set name_HK = '基礎資料更新',name_US = null where id = 972;
update system_menus set name_HK = '表單模版分類管理',name_US = null  where id = 980;
update system_menus set name_HK = '表單模版管理',name_US = null  where id = 981;

update system_perms set operation_HK = '通用許可權',operation_US = 'General powers' where id = 22;
update system_perms set operation_HK = '公文處理',operation_US = 'Workflow processing' where id = 23;
update system_perms set operation_HK = '用戶基本設置',operation_US = 'Users to the basic settings' where id = 24;
update system_perms set operation_HK = '公文統計報表',operation_US = 'Workflow statistics' where id = 25;
update system_perms set operation_HK = '通知公告管理',operation_US = 'Bulletin Board Management' where id = 26;
update system_perms set operation_HK = '通知公告',operation_US = 'Bulletin Board' where id = 27;
update system_perms set operation_HK = '工作流管理',operation_US = 'Workflow Management' where id = 28;
update system_perms set operation_HK = '電子郵件',operation_US = 'E-mail' where id = 29;
update system_perms set operation_HK = '系統新聞欄目管理',operation_US = 'Systems Management News section' where id = 30;
update system_perms set operation_HK = '系統新聞欄目管理（反向）',operation_US = 'Systems Management News column (reverse)' where id = 31;
update system_perms set operation_HK = '新聞發表',operation_US = 'News' where id = 32;
update system_perms set operation_HK = '新聞閱讀',operation_US = 'News reader' where id = 33;
update system_perms set operation_HK = '新聞審核',operation_US = 'Press review' where id = 34;
update system_perms set operation_HK = '新聞管理（反向）',operation_US = 'Information Management (reverse)' where id = 36;
update system_perms set operation_HK = '通知公告管理（反向）',operation_US = 'Announcement Management (reverse)' where id = 37;
update system_perms set operation_HK = '系統管理',operation_US = 'System Management' where id = 38;
update system_perms set operation_HK = '根欄目管理',operation_US = 'Management of the root section' where id = 39;
update system_perms set operation_HK = '普通欄目管理',operation_US = 'General management program' where id = 40;
update system_perms set operation_HK = '文章發表修改刪除',operation_US = 'Modify,delete,create article' where id = 41;
update system_perms set operation_HK = '文章閱讀',operation_US = 'Read the article' where id = 42;
update system_perms set operation_HK = '日程管理',operation_US = 'Schedule management' where id = 43;
update system_perms set operation_HK = '會議室管理',operation_US = 'Management Conference Room' where id = 44;
update system_perms set operation_HK = '會議管理',operation_US = 'Conference Management' where id = 45;
update system_perms set operation_HK = '論壇管理',operation_US = 'Forum Management' where id = 47;
update system_perms set operation_HK = '論壇訪問',operation_US = 'Forum Access' where id = 48;
update system_perms set operation_HK = '通訊錄管理',operation_US = 'Address Book Management' where id = 49;
update system_perms set operation_HK = '通訊錄',operation_US = 'Address Book' where id = 50;
update system_perms set operation_HK = '文件傳閱',operation_US = 'Circulation of papers' where id = 51;
update system_perms set operation_HK = '檔案管理',operation_US = 'File Management' where id = 52;
update system_perms set operation_HK = '檔案業務',operation_US = 'File operations' where id = 53;
update system_perms set operation_HK = '檔案錄入',operation_US = 'File entry' where id = 54;
update system_perms set operation_HK = '檔案查詢檢索',operation_US = 'Search Archives' where id = 55;
update system_perms set operation_HK = '辦公用品管理',operation_US = 'Management of office supplies' where id = 56;
update system_perms set operation_HK = '辦公庫管',operation_US = 'supply-Warehouse Manager' where id = 57;
update system_perms set operation_HK = '圖書系統管理',operation_US = 'Book Systems Management' where id = 58;
update system_perms set operation_HK = '圖書室管理員',operation_US = 'Library administrator' where id = 59;
update system_perms set operation_HK = '圖書檢索',operation_US = 'Book Search' where id = 60;
update system_perms set operation_HK = '手機短信',operation_US = 'SMS' where id = 61;
update system_perms set operation_HK = '友情連接',operation_US = 'Link' where id = 62;
update system_perms set operation_HK = '車輛系統管理',operation_US = 'Vehicle Systems Management' where id = 63;
update system_perms set operation_HK = '車輛管理員',operation_US = 'Vehicle Manager' where id = 64;
update system_perms set operation_HK = '車輛使用人員',operation_US = 'The use of staff vehicles' where id = 65;
update system_perms set operation_HK = '辦公用戶之普通用戶',operation_US = 'Ordinary office users users' where id = 66;
update system_perms set operation_HK = '登陸日誌管理員',operation_US = 'Log Manager landing' where id = 67;
update system_perms set operation_HK = '登陸日誌查詢',operation_US = 'Query log landing' where id = 68;
update system_perms set operation_HK = '電腦報修管理員',operation_US = 'Administrator computer repair' where id = 69;
update system_perms set operation_HK = '電腦報修維護員',operation_US = 'Computer repair maintenance staff' where id = 70;
update system_perms set operation_HK = '電腦報修人員',operation_US = 'Computer repair staff' where id = 71;
update system_perms set operation_HK = '年假維護管理',operation_US = 'Annual maintenance and management' where id = 72;
update system_perms set operation_HK = '檔案管理',operation_US = 'File Management' where id = 73;
update system_perms set operation_HK = '檔案業務',operation_US = 'File operations' where id = 74;
update system_perms set operation_HK = '調查投票管理員',operation_US = 'Investigation vote Manager' where id = 75;
update system_perms set operation_HK = '調查投票使用',operation_US = 'Investigate the use of voting' where id = 76;
update system_perms set operation_HK = '車輛部門審核員',operation_US = 'Vehicle sector auditors' where id = 77;
update system_perms set operation_HK = '人事資料管理',operation_US = 'Personnel data management' where id = 78;
update system_perms set operation_HK = '基本資料管理',operation_US = 'Basic data management' where id = 79;
update system_perms set operation_HK = '個人任務管理',operation_US = 'Personal task management' where id = 80;
update system_perms set operation_HK = '任務管理',operation_US = 'Task Manager' where id = 81;
update system_perms set operation_HK = '統計&報表',operation_US = 'Statistics & statements' where id = 82;
update system_perms set operation_HK = '通知公告審核',operation_US = 'Audit Notice' where id = 83;
update system_perms set operation_HK = '模組管理',operation_US = 'Module Management' where id = 85;

update system_perms set operation_HK = '公文交换',operation_US = null where id = 84;

update system_perms set operation_HK = '庫房管理',operation_US = 'Treasury Management' where id = 86;
update system_perms set operation_HK = '申請審批',operation_US = 'Application for approval' where id = 87;
update system_perms set operation_HK = '普通用戶',operation_US = 'Ordinary users' where id = 88;

update system_perms set operation_HK = '文檔流覽',operation_US = null where id = 90;
update system_perms set operation_HK = '許可權、空間管理',operation_US = null where id = 91;

update system_perms set operation_HK = '登陸日誌之普通用戶',operation_US = 'Ordinary users log landing' where id = 92;
update system_perms set operation_HK = '傳閱管理',operation_US = 'Circulation management' where id = 93;
update system_perms set operation_HK = 'pl報表管理',operation_US = 'statements of management pl' where id = 94;
update system_perms set operation_HK = 'pl報表通用許可權',operation_US = 'pl statements of general competence' where id = 95;


update system_perms set operation_HK = '發放工資條',operation_US = null where id = 94

update system_perms set operation_HK = 'pl報表管理',operation_US = 'statements of management pl' where id = 96
update system_perms set operation_HK = 'pl報表通用許可權',operation_US = 'pl statements of general competence' where id = 95


update system_perms set operation_HK = '我的便簽通用許可權',operation_US = null where id = 97
update system_perms set operation_HK = '日誌管理通用許可權',operation_US = null where id = 98
update system_perms set operation_HK = '任務管理通用許可權',operation_US = null where id = 99
update system_perms set operation_HK = '郵件管理',operation_US = null where id = 103
update system_perms set operation_HK = '新建通知公告',operation_US = null where id = 105
update system_perms set operation_HK = '我的日曆通用許可權',operation_US = null where id = 109
update system_perms set operation_HK = '計畫總結通用許可權',operation_US = null where id = 110
update system_perms set operation_HK = '計畫總結管理',operation_US = null where id = 111
update system_perms set operation_HK = '車輛管理員',operation_US = null where id = 113
update system_perms set operation_HK = '車輛使用人員',operation_US = null where id = 114
update system_perms set operation_HK = '車輛部門審核員',operation_US = null where id = 115
update system_perms set operation_HK = '車輛系統管理',operation_US = null where id = 116
update system_perms set operation_HK = '報表統計',operation_US = null where id = 117
update system_perms set operation_HK = '業務鏈結管理許可權',operation_US = null where id = 120
update system_perms set operation_HK = '業務鏈結流覽許可權',operation_US = null where id = 121


update archive2_fields set name_HK = '部門',name_US = 'Departments' where id =1;
update archive2_fields set name_HK = '全宗',name_US = 'Fonds' where id =2;
update archive2_fields set name_HK = '件號',name_US = 'No. cases' where id =3;
update archive2_fields set name_HK = '盒號',name_US = 'Box No.' where id =4;
update archive2_fields set name_HK = '檔號',name_US = 'Ref' where id =5;
update archive2_fields set name_HK = '歸檔狀態',name_US = 'Filing status' where id =6;
update archive2_fields set name_HK = '密級',name_US = 'Classification' where id =7;
update archive2_fields set name_HK = '歸檔年度',name_US = 'Filing the annual' where id =8;
update archive2_fields set name_HK = '題名',name_US = 'Title' where id =9;
update archive2_fields set name_HK = '主題詞',name_US = 'Keywords' where id =10;
update archive2_fields set name_HK = '存放位置',name_US = 'Location' where id =11;
update archive2_fields set name_HK = '備註',name_US = 'Remarks' where id =12;
update archive2_fields set name_HK = '部門',name_US = 'Departments' where id =13;
update archive2_fields set name_HK = '全宗',name_US = 'Fonds' where id =14;
update archive2_fields set name_HK = '件號',name_US = 'No. cases' where id =15;
update archive2_fields set name_HK = '盒號',name_US = 'Box No.' where id =16;
update archive2_fields set name_HK = '檔號',name_US = 'Ref' where id =17;
update archive2_fields set name_HK = '歸檔狀態',name_US = 'Filing status' where id =18;
update archive2_fields set name_HK = '密級',name_US = 'Classification' where id =19;
update archive2_fields set name_HK = '歸檔年度',name_US = 'Filing the annual' where id =20;
update archive2_fields set name_HK = '題名',name_US = 'Title' where id =21;
update archive2_fields set name_HK = '主題詞',name_US = 'Keywords' where id =22;
update archive2_fields set name_HK = '存放位置',name_US = 'Location' where id =23;
update archive2_fields set name_HK = '備註',name_US = 'Remarks' where id =24;
update archive2_fields set name_HK = '部門',name_US = 'Departments' where id =25;
update archive2_fields set name_HK = '全宗',name_US = 'Fonds' where id =26;
update archive2_fields set name_HK = '件號',name_US = 'No. cases' where id =27;
update archive2_fields set name_HK = '盒號',name_US = 'Box No.' where id =28;
update archive2_fields set name_HK = '檔號',name_US = 'Ref' where id =29;
update archive2_fields set name_HK = '歸檔狀態',name_US = 'Filing status' where id =30;
update archive2_fields set name_HK = '密級',name_US = 'Classification' where id =31;
update archive2_fields set name_HK = '歸檔年度',name_US = 'Filing the annual' where id =32;
update archive2_fields set name_HK = '題名',name_US = 'Title' where id =33;
update archive2_fields set name_HK = '主題詞',name_US = 'Keywords' where id =34;
update archive2_fields set name_HK = '存放位置',name_US = 'Location' where id =35;
update archive2_fields set name_HK = '備註',name_US = 'Remarks' where id =36;
update archive2_fields set name_HK = '部門',name_US = 'Departments' where id =37;
update archive2_fields set name_HK = '全宗',name_US = 'Fonds' where id =38;
update archive2_fields set name_HK = '件號',name_US = 'No. cases' where id =39;
update archive2_fields set name_HK = '盒號',name_US = 'Box No.' where id =40;
update archive2_fields set name_HK = '檔號',name_US = 'Ref' where id =41;
update archive2_fields set name_HK = '歸檔狀態',name_US = 'Filing status' where id =42;
update archive2_fields set name_HK = '密級',name_US = 'Classification' where id =43;
update archive2_fields set name_HK = '歸檔年度',name_US = 'Filing the annual' where id =44;
update archive2_fields set name_HK = '題名',name_US = 'Title' where id =45;
update archive2_fields set name_HK = '主題詞',name_US = 'Keywords' where id =46;
update archive2_fields set name_HK = '存放位置',name_US = 'Location' where id =47;
update archive2_fields set name_HK = '備註',name_US = 'Remarks' where id =48;
update archive2_fields set name_HK = '部門',name_US = 'Departments' where id =61;
update archive2_fields set name_HK = '全宗',name_US = 'Fonds' where id =62;
update archive2_fields set name_HK = '件號',name_US = 'No. cases' where id =63;
update archive2_fields set name_HK = '盒號',name_US = 'Box No.' where id =64;
update archive2_fields set name_HK = '檔號',name_US = 'Ref' where id =65;
update archive2_fields set name_HK = '歸檔狀態',name_US = 'Filing status' where id =66;
update archive2_fields set name_HK = '密級',name_US = 'Classification' where id =67;
update archive2_fields set name_HK = '歸檔年度',name_US = 'Filing the annual' where id =68;
update archive2_fields set name_HK = '題名',name_US = 'Title' where id =69;
update archive2_fields set name_HK = '主題詞',name_US = 'Keywords' where id =70;
update archive2_fields set name_HK = '存放位置',name_US = 'Location' where id =71;
update archive2_fields set name_HK = '備註',name_US = 'Remarks' where id =72;

update supply_report set name_HK='員工領用統計明細表',name_US='staff statistical breakdown recipients'  where id = 1;
update supply_report set name_HK='部門年度費用統計表',name_US='department annual cost of tables'  where id = 2;
update supply_report set name_HK='用品年度費用統計表',name_US='annual cost of supplies tables'  where id = 3;
update supply_report set name_HK='員工借用統計明細表',name_US='Employees to use statistical breakdown'  where id = 4;


---534 新样式  mskin


update F_POR_PAGE set name_HK = '協同審批',name_US = null where id = 1;
update F_POR_PAGE set name_HK = '知識中心',name_US = null where id = 2;
update F_POR_PAGE set name_HK = '資訊共用',name_US = null where id = 3;
update F_POR_PAGE set name_HK = '首頁',name_US = null where id = 4;
update F_POR_PAGE set name_HK = '配置管理',name_US = null where id = 7;
update F_POR_PAGE set name_HK = '資源管理',name_US = null where id = 8;
update F_POR_PAGE set name_HK = '互動溝通',name_US = null where id = 9;
update F_POR_PAGE set name_HK = '工作安排',name_US = null where id = 10;

commit;
